<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Using efficient search syntax</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ul.whs2 { list-style:square; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Searching for objects\nUsing efficient search syntax");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Using efficient search syntax</h1>
<p>You can use wildcard characters, such as an asterisk (*) or a question 
 mark (?), to represent one or more characters when you are typing search 
 terms. Wildcard characters are often used in place of one or more characters 
 when you do not know what the actual character is or you do not want to 
 type the entire name. </p>
<ul type="disc" class="whs1">
	
<li class=p><p>Use the asterisk (*) to substitute for one or more characters. 
 For example, <span class=Code>sales*</span> locates all words that contain 
 the word sales. The location of the asterisk is important: <span class=Code>sales*</span> 
 might bring back <span class=Code>salesman</span>, or <span class=Code>sales 
 tax</span>, but it would not find <span class=Code>dollar sales</span>. 
 To locate <span class=Code>dollar sales</span>, you could type <span class=Code>* 
 sales</span>. </p></li>
	
<li class=p><p>Use the question mark (?) to replace one character. 
 For example, if you type <span class=Code>sal</span>?, this would find 
 words like <span class=Code>sale</span>, or <span class=Code>sal2</span>, 
 but not <span class=Code>sales</span>, since there are two extra characters 
 in that term and the question mark only replaces one of them. </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p>You cannot use the question mark (?) wildcard to 
 search for attribute elements. For example, in the View Filter pane when 
 you click <span style="font-weight: bold;"><B>Select</B></span> and search for 
 attribute elements, you cannot use a question mark (?) as part of the 
 search.</p></li>
	</ul>
</ul>
<h2>Examples of correct and efficient search syntax</h2>
<p>The following examples assume that the attribute <span class=Code>Name</span> 
 has two display (browse) forms: <span class=Code>First</span> and <span 
 class=Code>Last</span>. <span class=Code>First</span> refers to the first 
 name and <span class=Code>Last</span> refers to the last name.</p>
<ul type="square" class="whs2">
	
<li style="list-style: disc;" type=disc class=p><p>Search keywords 
 that do not include wildcards have wildcards added at the beginning and 
 the end. </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p>User Input: aaa </p></li>
		
<li class=p><p>Filter: First Name like &quot;*aaa*&quot; or Last 
 Name like &quot;*aaa*&quot; </p></li>
	</ul>
</ul>
<ul type="disc" class="whs1">
	
<li class=p><p>Any text that is included inside of double-quotes is 
 treated as a literal comparison. For example: </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p>User Input: &quot;aaa&quot; </p></li>
		
<li class=p><p>Filter: First Name = &quot;aaa&quot; or Last Name 
 = &quot;aaa&quot; </p></li>
	</ul>
</ul>
<ul type="disc" class="whs1">
	
<li class=p><p>If you include wildcards, then MicroStrategy Web does 
 not add any. For example: </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p>User Input: aaa* </p></li>
		
<li class=p><p>Filter: First Name like &quot;aaa*&quot; or Last 
 Name like &quot;aaa*&quot;</p></li>
		
<li class=p><p>User Input: a*aa </p></li>
		
<li class=p><p>Filter: First Name like &quot;a*aa&quot; or Last 
 Name like &quot;a*aa&quot; </p></li>
	</ul>
</ul>
<ul type="disc" class="whs1">
	
<li class=p><p>A blank space, a comma, or the word OR indicates a logical 
 OR between two conditions. An OR is placed in between multiple forms. 
 </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p>User Input: aaa* *bbb User Input: aaa*,*bbb User 
 Input: aaa* OR *bbb </p></li>
		
<li class=p><p>Filter: (First Name like &quot;aaa*&quot; or Last 
 Name like &quot;aaa*&quot;) OR (First Name like &quot;*bbb&quot; or Last 
 Name like &quot;*bbb&quot;) </p></li>
	</ul>
</ul>
<ul type="disc" class="whs1">
	
<li class=p><p>A pipe symbol (|) or the word AND indicates a logical 
 AND between two conditions. An AND is placed between multiple forms. </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p>User Input: &quot;aaa&quot;|&quot;bbb&quot; User 
 Input: &quot;aaa&quot; AND &quot;bbb&quot; </p></li>
		
<li class=p><p>Filter: (First Name = &quot;aaa&quot; or Last Name 
 = &quot;aaa&quot;) AND (First Name = &quot;bbb&quot; or Last Name = &quot;bbb&quot;) 
 </p></li>
	</ul>
</ul>
<ul type="disc" class="whs1">
	
<li class=p><p>A form name (not case-sensitive) followed by a colon 
 can be used to search on a specific form. </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p>User Input: Last:aaa </p></li>
		
<li class=p><p>Filter: Last Name like &quot;*aaa*&quot;</p></li>
		
<li class=p><p>User Input: First:aaa OR Last:bbb OR ccc </p></li>
		
<li class=p><p>Filter: (First Name like &quot;*aaa*&quot;) or (Last 
 Name like &quot;*bbb*&quot;) or (First Name like &quot;*ccc*&quot; or 
 Last Name like &quot;*ccc*&quot;) </p></li>
	</ul>
</ul>
<h3>Related topics</h3>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="Advanced_search.htm">Searching by object type, 
 creation date, and other criteria</a></p></li>
	
<li class=p><p>
<a HREF="Searching_for_objects.htm">Searching for objects: 
 Simple search</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
